1 #-*-coding:utf-8-*-2 " "3 --------------------------------------------4 already has the function: Enter the user name password, the authentication succeeds displays the welcome message, after the mistake three times the permanent lock5 To be added later: timed unlock; Use a large number of storage users, such as databases, and call6 --------------------------------------------7 " "8Username ='AAA'9Password ='AAA'Ten One defUserLock (): ATry_times =0 - whileTry_times : -Usernameinput =
relationship, then will not delete this groupGroupadd zpyGroupdel zpy #因为组没有文件, so do not add-rUseradd-p Mima User #指定用户密码-U 1111 User #指定uid为1111-G 1111 User #指定gid if this group exists-C "Interpreting content" #指定解释内容-d/home/file User #指定家目录Note: Beginners must pay attention, the above for the establishment of the user when the way to specify some information, if you want to change, do not delete this user, re-establish by the way to specify, or use the following usermod instructions to make
We often see in the BBS to prohibit users to post, or lock users can not login, and so on, let's take a look at how these features are implemented by the program.
Sub LockUser ()
Dim UserStatus
If XmlDoc.documentElement.selectSingleNode ("UserStatus") is nothing Then
Messenge = "Status = 1
Exit Sub
ElseIf not IsNumeric (XmlDoc.documentElement.selectSingleNode ("UserStatus"). Text) Then
Messenge = "Status = 1
Exit Sub
Else
UserStatus = CLNG (XmlDoc.documentElement.selectSingleNode ("UserStatus").
Backup and restoration of MySQL Databases and tables, and backup of mysql DatabasesBackup
Export all database table Structures
mysqldump -uroot -ppassword -d dbname > db.sql
Export a table structure in the database
mysqldump -uroot -ppassword -d dbname tablename > db.sql
Export all database table structures and Data
mysqldump -uroot -ppassword dbname > db.sql
Export the structure and data of a table in the database
mysqldump -uroot -ppassword dbname tablename > db.sql
Export some data
-- Where =
difficult for companies to accept. There is also a third-party software called UserLock, which is very powerful but paid.The basic idea for implementing this function with scripts is as follows:1. When a user logs on, check all logon records of the current user in the database. If the account information is not found, Allow logon and record the Logon account, client location, and time;2. When another user logs on with the same account, the same check
to acquire a lock on page of a relation.
TupleWaiting to acquire a lock on a tuple.
TransactionIDWaiting for a transaction to finish.
VirtualxidWaiting to acquire a virtual XID lock.
Speculative tokenWaiting to acquire a speculative insertion lock.
ObjectWaiting to acquire a lock on a Non-relation database object.
UserLockWaiting to acquire a userlock.
AdvisoryWaiting to acquire an advisory user lock.2.4 Bufferpin
BufferpinWaiting to acquire
account management can create and delete users manually. Generally for convenience, useUseraddcommand to create a user,Usermodand theUserdelusers can be modified and deleted. can be usedusermod-l Userand theusermod-u UserLock and unlock users and prohibit users from logging in. passwdcommand to modify the user's password. Login Account RecordLinuxin the/var/run/utmpthe user who is currently logged on to the system is logged in the file/var/log/wtmplog
TransactionID */Locktag_virtualtransaction,/* Virtual transaction (ditto) *//* ID info for a virtual transaction are its Virtualtransactionid */Locktag_object,/* non-relation database OBJECT *//* ID info for a object is DB oid + CLASS OID + object OID + SUBID *//** Note:object ID have same representation as in Pg_depend and* Pg_description, but notice is constraining SUBID to + bits.* Also, we use the DB OID = 0 for shared objects such as tablespaces.*/Locktag_userlock,/* reserved for old contr
Contact Us
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.